Cloud data simplified: a great all-in-one tool for all your data analytics needs
Our data warehouse was growing at a 1TB/year rate, and we needed a solution that would be both cheap and effective.
Previously we were …
Previously we were …
Starting at $4,700 per month 5000 Synapse Commit Units (SCUs)
View PricingOverview
What is Azure Synapse Analytics?
Azure Synapse Analytics is described as the former Azure SQL Data Warehouse, evolved, and as a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives users the freedom to query data using either serverless…
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Pricing
Tier 1
$4,700
Cloud
per month 5,000 Synapse Commit Units (SCUs)
Tier 2
$9,200
Cloud
per month 10,000 Synapse Commit Units (SCUs)
Tier 3
$21,360
Cloud
per month 24,000 Synapse Commit Units (SCUs)
Entry-level set up fee?
- No setup fee
For the latest information on pricing, visithttps://azure.microsoft.com/en…
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Starting price (does not include set up fee)
- $4,700 per month 5000 Synapse Commit Units (SCUs)
Product Details
- About
- Tech Details
- FAQs
What is Azure Synapse Analytics?
Azure Synapse Analytics Technical Details
| Deployment Types | Software as a Service (SaaS), Cloud, or Web-Based |
|---|---|
| Operating Systems | Unspecified |
| Mobile Application | No |
Frequently Asked Questions
Azure Synapse Analytics is described as the former Azure SQL Data Warehouse, evolved, and as a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives users the freedom to query data using either serverless or provisioned resources, at scale. Azure Synapse brings these two worlds together with a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.
Azure Synapse Analytics starts at $4700.
The most common users of Azure Synapse Analytics are from Small Businesses (1-50 employees).
Comparisons
Compare with
Reviews and Ratings
(51)Attribute Ratings
Reviews
(1-2 of 2)Companies can't remove reviews or game the system. Here's why
March 17, 2022
Azure Synapse Does It All
As a consulting company, we implement data warehouse solutions for our clients. We use Azure Synapse for enterprises data warehouse implementations. Data from various internal sources like sales, finance and operations are integrated into Synapse via Azure Data Factory and Data Lake. It’s used as reporting data source for Microsoft Power BI as well.
- Data integration via poly base
- Data distribution
- Create table as select
- Resource allocation via user groups (for production ETL and report users)
- Integrating external 3rd party data sources is very easy in Snowflake and it’s missing in Azure Synapse
- Master data services and data quality services are missing in Azure Synapse. They are useful features present in on Orem Sql server
- Resource usage reports (top 10 expensive queries, most frequently run queries, etc) are a feature that can be added in Azure Synapse. It’s present in an on-prem SQL server. DMVs are there but viewing it visually as a report is more helpful.
- External table creation via polybase
- Azure Synapse workspace integration with Microsoft Power BI, data sources and Azure Data Factory
- Create table as select
- Licensing fees is replaced with Azure subscription fee. No big saving there
- More visibility into the Azure usage and cost
- It can be used a hot storage and old data can be archived to data lake. Real time data integration is possible via external tables and Microsoft Power BI
When client is already having or using Azure then it’s wise to go with Synapse rather than using Snowflake. We got a lot of help from Microsoft consultants and Microsoft partners while implementing our EDW via Synapse and support is easily available via Microsoft resources and blogs. I don’t see that with Snowflake
November 30, 2021
Satisfied DBA/Data engineer
I am an independent developer using Azure Synapse for other companies. My company is machinery production oriented (i.e. automotive companies) so I'm used to [utilizing] the Synapse for statistics-driven quality control, some logistics stuff, etc.
- The combination of SQL/unstructured data
- Keeping things "complicated, but simple"; [heterogeneous] data formats seen as just SQL tables to business experts used to use Power BI, Excel, and any other traditional SQL-oriented BI tools
- Integration options using "Synapse pipelines", the application of ADFs
- The greatly integrated solution of independent things (Spark MPP cluster, MPP SQL Servers, ADFs) - all sitting under one roof. Great job!
- Integration with super-fast, globally replicated data. I really appreciate the integration of NoSQL databases (namely Core API and Mongo API under Cosmos DB) with purely batch-processed BI data
- I have no idea right now. But... Synapse Analytics are typically seen as batch-processing of source data. What about tighter cooperation with streaming features like Event Hubs?
- It's actually hard to answer the question as it is built up, sorry. But imagine, you are used to [sending] paper letters to your customers. What are your spending [on] the letters? You have some imagination, however, but let's develop a simple chart showing your spendings related to any other spendings, or, more descriptively, compared with expected profit. Oh, my! Is it really so much? What about some e-mail campaign next time? We can talk about dozens of similar examples, folks. Until data is seen in graphical format, it's just some opinion on what's going on in our businesses.
- Using Synapse Analytics as well as any other cloud resource needs a big change to the administrator's mindset. Basically, the cloud is not just about technical skills like "I love the MPP approach of data processing", but it is about, says, economies of operations. Scaling stuff up and down, pausing servers, this is what the utilization of the cloud is all about! Go and mention it to people!